object FormBusca_Papel_viejo: TFormBusca_Papel_viejo
  Left = 601
  Top = 128
  Width = 581
  Height = 452
  Caption = 'Buscardor de papeles de Almacen'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poOwnerFormCenter
  OnActivate = FormActivate
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 0
    Top = 0
    Width = 573
    Height = 23
    Align = alTop
    Alignment = taCenter
    Caption = 'Buscar papel'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clMaroon
    Font.Height = -16
    Font.Name = 'Arial Black'
    Font.Style = []
    ParentFont = False
  end
  object pBuscar: TPanel
    Left = 0
    Top = 23
    Width = 573
    Height = 61
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 0
    object Label2: TLabel
      Left = 23
      Top = 22
      Width = 33
      Height = 13
      Caption = 'C'#243'digo'
    end
    object Label3: TLabel
      Left = 89
      Top = 22
      Width = 21
      Height = 13
      Caption = 'Tipo'
    end
    object Label4: TLabel
      Left = 250
      Top = 22
      Width = 24
      Height = 13
      Caption = 'Color'
    end
    object Label5: TLabel
      Left = 479
      Top = 22
      Width = 32
      Height = 13
      Caption = 'Familia'
    end
    object Label6: TLabel
      Left = 0
      Top = 0
      Width = 573
      Height = 13
      Align = alTop
      Alignment = taCenter
      Caption = 
        'Indica los criterios de busqueda que quieras en las casillas sig' +
        'uientes.'
    end
    object Label8: TLabel
      Left = 367
      Top = 22
      Width = 55
      Height = 13
      Caption = 'Generaci'#243'n'
    end
    object Label9: TLabel
      Left = 138
      Top = 22
      Width = 39
      Height = 13
      Caption = 'Gramaje'
    end
    object Label11: TLabel
      Left = 188
      Top = 22
      Width = 31
      Height = 13
      Caption = 'Ancho'
    end
    object Label12: TLabel
      Left = 307
      Top = 22
      Width = 27
      Height = 13
      Caption = 'Largo'
    end
    object eCodigo: TEdit
      Left = 14
      Top = 36
      Width = 50
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 0
      OnChange = eCodigoChange
    end
    object eTipo: TEdit
      Left = 64
      Top = 36
      Width = 70
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 1
      OnChange = eCodigoChange
    end
    object eColor: TEdit
      Left = 227
      Top = 36
      Width = 70
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 4
      OnChange = eCodigoChange
    end
    object eFamilia: TEdit
      Left = 445
      Top = 36
      Width = 100
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 7
      OnChange = eCodigoChange
    end
    object eGeneracion: TEdit
      Left = 344
      Top = 36
      Width = 100
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 6
      OnChange = eCodigoChange
    end
    object eGramage: TEdit
      Left = 135
      Top = 36
      Width = 45
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 2
      OnChange = eCodigoChange
    end
    object eAncho: TEdit
      Left = 181
      Top = 36
      Width = 45
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 3
      OnChange = eCodigoChange
    end
    object eLargo: TEdit
      Left = 298
      Top = 36
      Width = 45
      Height = 19
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 5
      OnChange = eCodigoChange
    end
  end
  object Grid: TXDBGrid
    Left = 0
    Top = 84
    Width = 573
    Height = 300
    Align = alClient
    DataSource = dsPapeles_Alm
    HeaderFont.Charset = DEFAULT_CHARSET
    HeaderFont.Color = clWindowText
    HeaderFont.Height = -11
    HeaderFont.Name = 'MS Sans Serif'
    HeaderFont.Style = []
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgTitleButtons, dgTitleHeaders, dgTitleWidthOff, dgMarkerAutoAlign, dgRowResize, dgRowScroll, dgMarkerAutoToggle, dgExtendedSelect, dgInternalSelect]
    ScrollBars = ssVertical
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnDblClick = GridDblClick
    OnPaintColumnCell = GridPaintColumnCell
    OnTitleClick = GridTitleClick
    Columns = <
      item
        Expanded = False
        FieldName = 'IDMATERIAL'
        Title.Caption = 'C'#243'digo'
        Visible = True
        Width = 50
      end
      item
        Expanded = False
        FieldName = 'TIPO_PAPEL'
        Title.Caption = 'Tipo'
        Visible = True
        Width = 70
      end
      item
        Expanded = False
        FieldName = 'GRAMAJE'
        Title.Caption = 'Gramaje'
        Visible = True
        Width = 45
      end
      item
        Expanded = False
        FieldName = 'ANCHO'
        Title.Caption = 'Ancho'
        Visible = True
        Width = 45
      end
      item
        Expanded = False
        FieldName = 'COLOR'
        Title.Caption = 'Color'
        Visible = True
        Width = 70
      end
      item
        Expanded = False
        FieldName = 'LARGO'
        Title.Caption = 'Largo'
        Visible = True
        Width = 45
      end
      item
        Expanded = False
        FieldName = 'GENERACION'
        Title.Caption = 'Generaci'#243'n'
        Visible = True
        Width = 100
      end
      item
        Expanded = False
        FieldName = 'FAMILIA'
        Title.Caption = 'Familia'
        Visible = True
        Width = 100
      end>
  end
  object pBotones: TPanel
    Left = 0
    Top = 384
    Width = 573
    Height = 41
    Align = alBottom
    TabOrder = 2
    DesignSize = (
      573
      41)
    object BtnAceptar: TBitBtn
      Left = 348
      Top = 10
      Width = 100
      Height = 26
      Anchors = [akTop, akRight, akBottom]
      Caption = 'Seleccionar'
      TabOrder = 0
      OnClick = BtnAceptarClick
      Kind = bkOK
    end
    object BtnCancelar: TBitBtn
      Left = 458
      Top = 10
      Width = 100
      Height = 26
      Anchors = [akTop, akRight, akBottom]
      Caption = 'Cancelar'
      TabOrder = 1
      Kind = bkCancel
    end
  end
  object qPapeles_Alm: TZReadOnlyQuery
    Connection = md.BBDD
    SQL.Strings = (
      
        'SELECT MA.IDMATERIAL, MA.REFERENCIA, PR.RAZONSOCIAL PROVEEDOR, T' +
        'P.DESCRIPCION TIPO_PAPEL, MA.LASER, GE.DESCRIPCION GENERACION, M' +
        'A.GRAMAJE, TU.DESCRIPCION UNIDADES, MA.LARGO, MA.ANCHO, MA.FAMIL' +
        'IA, MA.PRECIOCOMPRA,'#10
      'CASE MA.FAMILIA'#10
      
        #9#9'WHEN '#39'Bobinas'#39' THEN ( SELECT DESCRIPCION FROM ALM_COLORES_BOB ' +
        'WHERE IDCOLOR = MA.IDCOLOR)'#10
      
        #9#9'WHEN '#39'Papel'#39'   THEN ( SELECT DESCRIPCION FROM ALM_COLORES_PAPE' +
        'L WHERE IDCOLOR = MA.IDCOLOR)'#10
      
        #9#9'WHEN '#39'Sobres y Bolsas'#39' THEN (SELECT DESCRIPCION FROM ALM_COLOR' +
        'ES_SYB WHERE IDCOLOR = MA.IDCOLOR)'#10
      #9'END COLOR'#9#10
      'FROM ALM_MATERIASPRIMAS MA'#10
      
        #9'LEFT JOIN ALM_PROVEEDORES PR ON MA.IDPROVEEDOR = PR.IDPROVEEDOR' +
        #10
      
        #9'LEFT JOIN ALM_TIPOSDEPAPEL TP ON MA.IDTIPODEPAPEL = TP.IDTIPODE' +
        'PAPEL'#10
      
        #9'LEFT JOIN ALM_GENERACIONES GE ON MA.IDGENERACION = GE.IDGENERAC' +
        'ION'#10
      
        #9'LEFT JOIN ALM_TIPOSDEUNIDAD TU ON MA.IDTIPOUNIDAD = TU.IDTIPODE' +
        'UNIDAD '#10
      #10
      #10)
    Params = <>
    Left = 188
    Top = 324
  end
  object dsPapeles_Alm: TDataSource
    DataSet = qPapeles_Alm
    Left = 220
    Top = 324
  end
end
